use Dosvid
go

if exists(select 1
		  from sysobjects
		  where name = 'SexVariants')
  drop table SexVariants
go

create table SexVariants
(
  Id int identity(1,1) not null,
  SexName nvarchar(100) not null,
  UseInVacancy bit not null
)  
go

alter table SexVariants add constraint PK_SexVariants_ID primary key(Id)
go


alter table SexVariants with check add constraint DF_SexVariants_UseInVacancy
      default (0) for UseInVacancy
go